[mysql] how to find a value in the row?
Posted
by www.yegorov-p.ru
on Stack Overflow
See other posts from Stack Overflow
or by www.yegorov-p.ru
Published on 2010-05-11T06:27:19Z
Indexed on
2010/05/11
6:34 UTC
Read the original article
Hit count: 281
Hello.
I have pretty big table with lots of columns. I want to find all lines, with some word in it.
Sure, i can write something like
SELECT * FROM table WHERE 'blablabla' IN col1 OR 'blablabla' IN col2 OR ...
But I think it's not the best solution =))
© Stack Overflow or respective owner